/*
 Navicat Premium Data Transfer

 Source Server         : demo
 Source Server Type    : MySQL
 Source Server Version : 80031
 Source Host           : localhost:3306
 Source Schema         : day15-week3

 Target Server Type    : MySQL
 Target Server Version : 80031
 File Encoding         : 65001

 Date: 08/04/2023 11:38:48
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for employee_dept
-- ----------------------------
DROP TABLE IF EXISTS `employee_dept`;
CREATE TABLE `employee_dept` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of employee_dept
-- ----------------------------
BEGIN;
INSERT INTO `employee_dept` (`id`, `name`) VALUES (1, '销售');
INSERT INTO `employee_dept` (`id`, `name`) VALUES (2, '技术');
INSERT INTO `employee_dept` (`id`, `name`) VALUES (3, '总裁');
COMMIT;

-- ----------------------------
-- Table structure for employee_group
-- ----------------------------
DROP TABLE IF EXISTS `employee_group`;
CREATE TABLE `employee_group` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of employee_group
-- ----------------------------
BEGIN;
INSERT INTO `employee_group` (`id`, `name`) VALUES (1, '客运路');
INSERT INTO `employee_group` (`id`, `name`) VALUES (2, '和平路');
INSERT INTO `employee_group` (`id`, `name`) VALUES (3, '河西路');
COMMIT;

-- ----------------------------
-- Table structure for employee_info
-- ----------------------------
DROP TABLE IF EXISTS `employee_info`;
CREATE TABLE `employee_info` (
  `id` int NOT NULL AUTO_INCREMENT,
  `dept_id` int DEFAULT NULL,
  `group_id` int DEFAULT NULL,
  `num` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `sex` int DEFAULT NULL,
  `birthday` datetime DEFAULT NULL,
  `kaoqin` int DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `del` int DEFAULT '0' COMMENT '默认是0 代表未删除, 1已删除',
  PRIMARY KEY (`id`),
  KEY `idx_mix` (`dept_id`,`group_id`,`kaoqin`,`create_time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of employee_info
-- ----------------------------
BEGIN;
INSERT INTO `employee_info` (`id`, `dept_id`, `group_id`, `num`, `name`, `sex`, `birthday`, `kaoqin`, `create_time`, `status`, `del`) VALUES (1, 1, 1, 'fsdfse3', '坤', 1, '2023-04-01 10:06:06', 1, '2023-04-02 10:06:14', '在职', 0);
INSERT INTO `employee_info` (`id`, `dept_id`, `group_id`, `num`, `name`, `sex`, `birthday`, `kaoqin`, `create_time`, `status`, `del`) VALUES (2, 1, 1, 'fsdfse4', '凡', 1, '2023-04-01 10:06:06', 1, '2023-04-02 10:06:14', '在职', 0);
INSERT INTO `employee_info` (`id`, `dept_id`, `group_id`, `num`, `name`, `sex`, `birthday`, `kaoqin`, `create_time`, `status`, `del`) VALUES (3, 2, 2, 'fsdfse5', '峰', 1, '2023-03-01 10:06:06', 1, '2023-03-02 10:06:14', '在职', 0);
INSERT INTO `employee_info` (`id`, `dept_id`, `group_id`, `num`, `name`, `sex`, `birthday`, `kaoqin`, `create_time`, `status`, `del`) VALUES (4, 3, 3, 'fsdfse36', '博', 1, '2023-02-01 10:06:06', 1, '2023-02-02 10:06:14', '在职', 0);
INSERT INTO `employee_info` (`id`, `dept_id`, `group_id`, `num`, `name`, `sex`, `birthday`, `kaoqin`, `create_time`, `status`, `del`) VALUES (5, 1, 1, 'fsdfse7', '兴', 1, '2023-01-01 10:06:06', 2, '2023-01-02 10:06:14', '在职', 0);
INSERT INTO `employee_info` (`id`, `dept_id`, `group_id`, `num`, `name`, `sex`, `birthday`, `kaoqin`, `create_time`, `status`, `del`) VALUES (6, 1, 1, 'GF123456', '张三', NULL, NULL, 1, '2023-04-01 00:00:00', NULL, 0);
INSERT INTO `employee_info` (`id`, `dept_id`, `group_id`, `num`, `name`, `sex`, `birthday`, `kaoqin`, `create_time`, `status`, `del`) VALUES (7, 1, 1, 'GF12345678', '张三', NULL, NULL, 1, '2023-04-06 00:00:00', NULL, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
